--------------------
Installing Northwind
--------------------

These examples use the Northwind sample database, which may or not be installed
on your database server. (For example, SQL Server 2005 does not include
the Northwind database by default, unlike earlier versions.)

You can install the databases you need (complete with sample data) using
the InstNwnd.sql script included in this folder.

* If you're using a full version of SQL Server, you can open these scripts
and run them using a graphical tool like Query Analyzer.

* If you're using SQL Server 2005 Express Edition, you'll need to use the
sqlcmd.exe command-line tool. You need a run a command like this in a Command
Prompt window:

  sqlcmd -S localhost\SQLEXPRESS -i InstNwnd.sql

* If you're using a full version of SQL Server 2005 on the local computer,
you need a command like this:

  sqlcmd -i InstNwnd.sql


------------------------
Connecting to SQL Server
------------------------

These examples require SQL Server 7, SQL Server 2000, or SQL Server 2005.
You may need to modify the connection strings for your database server.

The samples use a connection string like this:

Dim Connect As String = "Data Source=localhost;Integrated Security=SSPI;" & _
    "Initial Catalog=Northwind;"

* If you're using a SQL Server instance on another computer, you'll need
to use the server name instead of localhost. 

* If you aren't using integrated security, you will have to replace this with a connection string like this for the sa account (although it will vary
depending on your database and whether you have configured a special password):

Dim Connect As String = "Data Source=localhost;user id=sa;" & _
    "Initial Catalog=Northwind;"

* If you're using SQL Server 2005 Express Edition, you need a connection string
like this instead:

Dim Connect As String = "Data Source=localhost\SQLEXPRESS;Integrated Security=SSPI;" & _
    "Initial Catalog=Northwind;"




